When the product setup.exe creates a new iMIS database, two SQL logins are created on the SQL Server instance that are used for system-level authentication of database transactions initiated by an iMIS user. These special logins prevent the need for any iMIS user to have a defined login or user on the SQL Server instance or iMIS database. Neither login is a member of any server role.
■ manager_[db] (where [db] is your iMIS database) is used by every iMIS user record that is a member of the SysAdmin role in iMIS Desktop.
□ This login is a member of the database roles db_owner and public.
□ As a member of the db_owner role, it enables activities such as rebuilding tables from iMIS Desktop.
■ imisuser_[db] (where [db] is your iMIS database) is used by every iMIS user record that is not a member of the iMIS Desktop SysAdmin role in iMIS Desktop.
□ This login is a member of the database roles IMIS and public.
□ Not a member of the db_owner role, activities such as rebuilding tables are unavailable.
To reset authentication passwords automatically
■ In DB Maintenance, run Prepare iMIS Database.
This resets an iMIS database that has just been restored to a new location or under a new name.
To reset authentication passwords manually
Note: Rarely, if ever, will you need to reset the hashed passwords for these special SQL logins. Should you need to, follow this procedure carefully.
1. If needed, grant access to the iMIS SQL Server login password for the SQL Server instance on which the iMIS database exists. (Only that login can update other SQL logins.)
2. In iMIS Desktop, log in as MANAGER.
3. Select File > System Setup.
4. On the System Setup window, click SQL Security Setup.
5. For manager_[db], enter a string identically in both SQL Manager Password and Verify Password. (The string does not matter: it becomes a hashed value.)
6. For imisuser_[db] enter a string identically in both SQL User Password, Verify Password.
7. Click Save to create the hashed password values stored in the System_Params table.
8. Click Create SQL Logins to reset the hashed passwords for the logins on the SQL Server instance.
9. When prompted, enter the sa password and accept any messages that appear regarding shutting down iBO on the appserver.